class CreatePeople < ActiveRecord::Migration
  def self.up
    create_table :people do |t|
      t.column :type, :string
      t.column :first_contact, :date
      t.column :school, :string
      t.column :name, :string
      t.column :parent_name, :string
      t.column :case_manager, :string
      t.column :victimization_type, :string
      t.column :primary_crime, :string
      t.column :all_crimes_involved, :string
      t.column :is_parent?, :boolean
      t.column :met_with_cm?, :boolean
      t.column :number_of_children, :integer
      t.column :children_names, :string
      t.column :followup_provided?, :boolean
      t.column :birthday, :date
      t.column :gender, :string
      t.column :ethnic_group, :string
      t.column :relationship_to_perp, :string
      t.column :underserved_population, :string
      t.column :city, :string
      t.column :zip_code, :string
      t.column :language, :string
      t.column :financial_status, :string
      t.column :has_transportation, :boolean
      t.column :medications, :text
      t.column :injuries, :text
      t.column :special_accomodations, :text
      t.column :created_on, :datetime
      t.column :updated_at, :datetime
    end
  end

  def self.down
    drop_table :people
  end
end
